-- Execute as sys

SELECT segment_name, segment_type, segment_subtype 
FROM dba_segments
WHERE tablespace_name = 'LOB_TBS2'
AND segment_type = 'LOBSEGMENT';
